checkpoint
go
BACKUP LOG TNG WITH TRUNCATE_ONLY
go
checkpoint
go
DBCC SHRINKFILE (TNG_Log, 30000)
go
checkpoint
go

